/*
 Navicat MySQL Data Transfer

 Source Server         : wxing
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : wxing-ghost

 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 05/15/2017 17:22:36 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `accesstokens`
-- ----------------------------
DROP TABLE IF EXISTS `accesstokens`;
CREATE TABLE `accesstokens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `expires` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accesstokens_token_unique` (`token`),
  KEY `accesstokens_user_id_foreign` (`user_id`),
  KEY `accesstokens_client_id_foreign` (`client_id`),
  CONSTRAINT `accesstokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `accesstokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `accesstokens`
-- ----------------------------
BEGIN;
INSERT INTO `accesstokens` VALUES ('14', 'ATKuRuYUHyUQpGucXPQhNuC7aQnslPwOjW0h7vPhHzv7mdhYv4chUvBWEdK5u8kfCUhtQNUvGmV97OTsrhw2WFn1CpsKTa3XZ7f8Jz0kh7AiPMJoYWIq2IMC2SYUEsj4RluEyjZ1REU6kdJmKmQWlQOO3mC7TLedIb7Vuyqdhg1OHnY1isLEMWhw3QQemRyF95I570XOcxyiIu8o7101wN0QWAEGsE9tBqGIv8pM3jwPB45AZoxRgqRhIcGnfHE', '1', '1', '1491965668617'), ('15', 'PYd5w7maxbicokPz98Cwr3zRSI3lfMfDxJ8pYLvUquxVSYPDwbwgQ5wXXlAOz2UfcT9LPpOHXYxmyl39wM3AvrBU2dunpAhWNSH2R9ISsVa1CRvYL1mTaHFMn8jxb4Jpe5GF42yWGEZiMFzfPxsNAACkyjuXYwGjRirJRthJ8SgpAZJ4bzSJGfypyrCdo6Lc1PocZQAHF5nOTrBKZbrebh2ONrD74v9smqzZz41NEBzprIEKHUBzFvZg2mTUrmq', '1', '1', '1491969262668');
COMMIT;

-- ----------------------------
--  Table structure for `app_fields`
-- ----------------------------
DROP TABLE IF EXISTS `app_fields`;
CREATE TABLE `app_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `key` varchar(150) NOT NULL,
  `value` text,
  `type` varchar(150) NOT NULL DEFAULT 'html',
  `app_id` int(10) unsigned NOT NULL,
  `relatable_id` int(10) unsigned NOT NULL,
  `relatable_type` varchar(150) NOT NULL DEFAULT 'posts',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `app_fields_app_id_foreign` (`app_id`),
  CONSTRAINT `app_fields_app_id_foreign` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `app_settings`
-- ----------------------------
DROP TABLE IF EXISTS `app_settings`;
CREATE TABLE `app_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `key` varchar(150) NOT NULL,
  `value` text,
  `app_id` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_settings_key_unique` (`key`),
  KEY `app_settings_app_id_foreign` (`app_id`),
  CONSTRAINT `app_settings_app_id_foreign` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `apps`
-- ----------------------------
DROP TABLE IF EXISTS `apps`;
CREATE TABLE `apps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `version` varchar(150) NOT NULL,
  `status` varchar(150) NOT NULL DEFAULT 'inactive',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `apps_name_unique` (`name`),
  UNIQUE KEY `apps_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `client_trusted_domains`
-- ----------------------------
DROP TABLE IF EXISTS `client_trusted_domains`;
CREATE TABLE `client_trusted_domains` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `trusted_domain` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_trusted_domains_client_id_foreign` (`client_id`),
  CONSTRAINT `client_trusted_domains_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `clients`
-- ----------------------------
DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `secret` varchar(150) NOT NULL,
  `redirection_uri` varchar(2000) DEFAULT NULL,
  `logo` varchar(2000) DEFAULT NULL,
  `status` varchar(150) NOT NULL DEFAULT 'development',
  `type` varchar(150) NOT NULL DEFAULT 'ua',
  `description` varchar(200) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clients_name_unique` (`name`),
  UNIQUE KEY `clients_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `clients`
-- ----------------------------
BEGIN;
INSERT INTO `clients` VALUES ('1', '487b1424-9039-4a74-9be1-f9b30bd9bc60', 'Ghost Admin', 'ghost-admin', '7a08144771c5', null, null, 'enabled', 'ua', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('2', 'c6b46afd-a5ff-4286-a610-8a874cc4b0c6', 'Ghost Frontend', 'ghost-frontend', '7041914d719f', null, null, 'enabled', 'ua', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1');
COMMIT;

-- ----------------------------
--  Table structure for `permissions`
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `object_type` varchar(150) NOT NULL,
  `action_type` varchar(150) NOT NULL,
  `object_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `permissions`
-- ----------------------------
BEGIN;
INSERT INTO `permissions` VALUES ('1', '904c7a3e-cbd5-40b9-b30b-0bc7c5daecab', 'Export database', 'db', 'exportContent', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('2', '4291ebcf-7a2f-4a24-bb6a-b392bb2b2245', 'Import database', 'db', 'importContent', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('3', '0c5cc9c8-9799-4fe6-9b22-0a5177d20abb', 'Delete all content', 'db', 'deleteAllContent', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('4', '785662bb-f16d-4862-a0d8-8769a4178e88', 'Send mail', 'mail', 'send', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('5', '776c3a3d-257a-4d6f-9c26-ffbfa3c09597', 'Browse notifications', 'notification', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('6', '7ec8fdf7-5888-404c-b1dd-45fd02965e2f', 'Add notifications', 'notification', 'add', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('7', '98233c4b-f76d-4132-a31e-4b39a3649f90', 'Delete notifications', 'notification', 'destroy', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('8', 'ff0738f5-5cf0-4a9a-be5a-a918046b2062', 'Browse posts', 'post', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('9', '8c570015-cae4-4c10-bca8-b7bcab41e646', 'Read posts', 'post', 'read', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('10', '0a7ec4db-2577-48b5-86f5-4e0deb3c08df', 'Edit posts', 'post', 'edit', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('11', 'bfb6bdbd-b486-4c8d-aae6-3383f6a1dc02', 'Add posts', 'post', 'add', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('12', '2850f13d-c5bb-4d50-8401-427790145894', 'Delete posts', 'post', 'destroy', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('13', 'a36f98be-7485-4488-8d3b-98c51d08c72c', 'Browse settings', 'setting', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('14', '7dc57f5f-d854-4b74-bfbb-5b4673bbfe05', 'Read settings', 'setting', 'read', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('15', '37fcdcca-4ccc-47e3-b219-362f0103c31c', 'Edit settings', 'setting', 'edit', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('16', 'c4d90d08-1593-42af-b49e-f0ca8c90fea5', 'Generate slugs', 'slug', 'generate', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('17', 'ce62d38f-08b8-4b32-8433-758d7494561a', 'Browse tags', 'tag', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('18', '5b4007fc-11e9-4e76-864c-83ce2f2cd0b5', 'Read tags', 'tag', 'read', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('19', '4eba64cd-ea62-45c1-929b-b9e52ef21290', 'Edit tags', 'tag', 'edit', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('20', '578cdfd4-4c08-4aa9-9776-c4aa5d7e923f', 'Add tags', 'tag', 'add', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('21', 'e666efc3-9edb-4898-992d-e9e1e459be62', 'Delete tags', 'tag', 'destroy', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('22', '6138fb5a-7ee2-4331-bbe5-211d36cf583e', 'Browse themes', 'theme', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('23', '99de770f-a4d1-49ee-95b9-28ef9f7ea5f8', 'Edit themes', 'theme', 'edit', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('24', '0bc8333c-f083-4739-888e-103af5252380', 'Browse users', 'user', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('25', 'c0b17352-29fd-4d46-954a-2a156cc184be', 'Read users', 'user', 'read', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('26', '163fead1-22ad-48a4-8846-4f2272cfe116', 'Edit users', 'user', 'edit', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('27', '8b5dd21b-0803-43ce-8df3-d4d60a02076c', 'Add users', 'user', 'add', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('28', '35ff8d1b-e37d-4ca9-91e2-ba19fc8fc084', 'Delete users', 'user', 'destroy', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('29', 'e24dec93-eb62-4fa5-92ee-4da16e174da7', 'Assign a role', 'role', 'assign', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('30', '8e0226ec-76f9-4b33-96b2-03a67e465eca', 'Browse roles', 'role', 'browse', null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1');
COMMIT;

-- ----------------------------
--  Table structure for `permissions_apps`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_apps`;
CREATE TABLE `permissions_apps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `permissions_roles`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_roles`;
CREATE TABLE `permissions_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `permissions_roles`
-- ----------------------------
BEGIN;
INSERT INTO `permissions_roles` VALUES ('1', '2', '8'), ('2', '2', '9'), ('3', '2', '10'), ('4', '2', '11'), ('5', '2', '12'), ('6', '2', '13'), ('7', '2', '14'), ('8', '2', '16'), ('9', '2', '17'), ('10', '2', '18'), ('11', '2', '19'), ('12', '2', '20'), ('13', '2', '21'), ('14', '2', '24'), ('15', '2', '25'), ('16', '2', '26'), ('17', '2', '27'), ('18', '2', '28'), ('19', '2', '29'), ('20', '2', '30'), ('21', '1', '1'), ('22', '1', '2'), ('23', '1', '3'), ('24', '1', '4'), ('25', '1', '5'), ('26', '1', '6'), ('27', '1', '7'), ('28', '1', '8'), ('29', '1', '9'), ('30', '1', '10'), ('31', '1', '11'), ('32', '1', '12'), ('33', '1', '13'), ('34', '1', '14'), ('35', '1', '15'), ('36', '1', '16'), ('37', '1', '17'), ('38', '1', '18'), ('39', '1', '19'), ('40', '1', '20'), ('41', '1', '21'), ('42', '1', '22'), ('43', '1', '23'), ('44', '1', '24'), ('45', '1', '25'), ('46', '1', '26'), ('47', '1', '27'), ('48', '1', '28'), ('49', '1', '29'), ('50', '1', '30'), ('51', '3', '8'), ('52', '3', '9'), ('53', '3', '11'), ('54', '3', '13'), ('55', '3', '14'), ('56', '3', '16'), ('57', '3', '17'), ('58', '3', '18'), ('59', '3', '20'), ('60', '3', '24'), ('61', '3', '25'), ('62', '3', '30');
COMMIT;

-- ----------------------------
--  Table structure for `permissions_users`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_users`;
CREATE TABLE `permissions_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `posts`
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `title` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `markdown` mediumtext,
  `html` mediumtext,
  `image` text,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `page` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(150) NOT NULL DEFAULT 'draft',
  `language` varchar(6) NOT NULL DEFAULT 'zh_CN',
  `meta_title` varchar(150) DEFAULT NULL,
  `meta_description` varchar(200) DEFAULT NULL,
  `author_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `published_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `posts`
-- ----------------------------
BEGIN;
INSERT INTO `posts` VALUES ('1', '090166c7-0edc-45ea-9322-9d322d40c6f9', 'æ¬¢è¿Žä½¿ç”¨ Ghost åšå®¢ç³»ç»Ÿ', 'welcome-to-ghost', 'Yeahï¼Œåšå®¢ä¸Šçº¿äº†ï¼è¿™ç¯‡æ–‡ç« çš„ç›®çš„æ˜¯å‘ä½ ä»‹ç» Ghost ç¼–è¾‘å™¨å¹¶å¸®ä½ å¿«é€Ÿä¸Šæ‰‹ã€‚é€šè¿‡ `<your blog URL>/ghost/` é“¾æŽ¥å°±å¯ä»¥ç™»å½•ç³»ç»ŸåŽå°ç®¡ç†ä½ çš„åšå®¢å†…å®¹äº†ã€‚å½“ä½ è¿›å…¥åŽå°ï¼Œä½ å°±èƒ½çœ‹åˆ°å·¦ä¾§æ–‡ç« åˆ—è¡¨å¤„åˆ—å‡ºçš„è¿™ç¯‡æ–‡ç« ï¼Œå³ä¾§å°±æ˜¯è¿™ç¯‡æ–‡ç« çš„é¢„è§ˆæ•ˆæžœã€‚ç‚¹å‡»é¢„è§ˆæ å³ä¸Šè§’çš„é“…ç¬”å›¾æ ‡å°±èƒ½è¿›å…¥å†…å®¹ç¼–è¾‘é¡µé¢ã€‚ \r\n\r\n## å¿«é€Ÿå…¥é—¨\r\n\r\nGhost ä½¿ç”¨ Markdown è¯­æ³•ä¹¦å†™å†…å®¹ã€‚ç®€å•æ¥è¯´ï¼ŒMarkdown å°±æ˜¯ä¸€ç§ç®€åŒ–çš„ä¹¦å†™æ ¼å¼ï¼\r\n\r\nç”¨ Markdown è¯­æ³•å†™ä½œæ˜¯å¾ˆå®¹æ˜“çš„ã€‚åœ¨ç¼–è¾‘ç•Œé¢çš„å·¦ä¾§å°±æ˜¯ä½ å†™ä½œçš„åœ°æ–¹ã€‚åœ¨ä½ è®¤ä¸ºéœ€è¦çš„æ—¶å€™ï¼Œå¯ä»¥ä½¿ç”¨ä»¥ä¸‹è¿™äº›è¯­æ³•æ¥æ ¼å¼åŒ–ä½ çš„å†…å®¹ã€‚ä¾‹å¦‚ä¸‹é¢è¿™ä¸ªæ— åºåˆ—è¡¨ï¼š\r\n\r\n* Item number one\r\n* Item number two\r\n    * A nested item\r\n* A final item\r\n\r\nè¿˜å¯ä»¥æ˜¯æœ‰åºåˆ—è¡¨ï¼š\r\n\r\n1. Remember to buy some milk\r\n2. Drink the milk\r\n3. Tweet that I remembered to buy the milk, and drank it\r\n\r\n### é“¾æŽ¥\r\n\r\nå¦‚æžœè¦é“¾æŽ¥å…¶å®ƒé¡µé¢ï¼Œå¯ä»¥ç›´æŽ¥æŠŠé¡µé¢çš„ URL ç²˜è´´è¿‡æ¥ï¼Œä¾‹å¦‚ http://www.ghostchina.com - ä¼šè¢«è‡ªåŠ¨è¯†åˆ«ä¸ºé“¾æŽ¥ã€‚ä½†æ˜¯ï¼Œå¦‚æžœä½ æƒ³è‡ªå®šä¹‰é“¾æŽ¥æ–‡æœ¬ï¼Œå¯ä»¥åƒè¿™æ ·ï¼š [Ghost ä¸­æ–‡ç½‘](http://www.ghostchina.com)ã€‚å¾ˆç®€å•å§ï¼\r\n\r\n### å›¾ç‰‡\r\n\r\næ’å…¥å›¾ç‰‡ä¹Ÿæ²¡é—®é¢˜ï¼å‰ææ˜¯ä½ äº‹å…ˆçŸ¥é“å›¾ç‰‡çš„ URLï¼Œç„¶åŽåƒä¸‹é¢è¿™æ ·ï¼š\r\n\r\n![The Ghost Logo](http://static.ghostchina.com/image/3/fe/34a9831916be9db1381ecb320491e.png)\r\n\r\nå¦‚æžœå›¾ç‰‡åœ¨æœ¬åœ°çš„ç¡¬ç›˜é‡Œæ€Žä¹ˆåŠžï¼Ÿä¹Ÿå¾ˆç®€å•ï¼åƒä¸‹é¢è¿™æ ·ä¹¦å†™å°±èƒ½ä¸ºå›¾ç‰‡é¢„ç•™ä¸€ä¸ªä½ç½®ï¼Œç„¶åŽä½ å¯ä»¥ç»§ç»­å†™ä½œï¼Œå›žå¤´å†é€šè¿‡æ‹–æ‹½çš„æ–¹å¼æŠŠå›¾ç‰‡ä¸Šä¼ åˆ°æœåŠ¡å™¨ä¸Šã€‚\r\n\r\n![ä¸€å¼ å›¾ç‰‡]\r\n\r\n\r\n### å¼•ç”¨\r\n\r\næœ‰äº›æ—¶å€™æˆ‘ä»¬éœ€è¦å¼•ç”¨åˆ«äººè¯´çš„è¯ï¼Œå¯ä»¥è¿™æ ·ï¼š\r\n\r\n> Wisdomous - it\'s definitely a word.\r\n\r\n### ä»£ç \r\n\r\næˆ–è®¸ä½ æ˜¯ä¸ªç å†œï¼Œéœ€è¦è´´ä¸€äº›ä»£ç åˆ°æ–‡ç« é‡Œï¼Œå¯ä»¥é€šè¿‡ä¸¤ä¸ªå¼•å·ï¼ˆTab é”®ä¸Šé¢çš„é‚£ä¸ªé”®ï¼‰åŠ å…¥è¡Œå†…ä»£ç  `<code>`ã€‚å¦‚æžœéœ€è¦åŠ å…¥å¤§æ®µçš„ä»£ç ï¼Œå¯ä»¥åœ¨ä»£ç å‰åŠ  4 ä¸ªç©ºæ ¼ç¼©è¿›ï¼Œè¿™å°±æ˜¯ Markdown çš„è¯­æ³•ã€‚\r\n\r\n    .awesome-thing {\r\n        display: block;\r\n        width: 100%;\r\n    }\r\n\r\n### åˆ†å‰²çº¿\r\n\r\nåœ¨ä»»ä¸€æ–°è¡Œè¾“å…¥ 3 ä¸ªæˆ–æ›´å¤šçš„çŸ­æ¨ªçº¿ï¼ˆå‡å·ï¼‰å°±æ˜¯ä¸€æ¡åˆ†éš”çº¿äº†ã€‚\r\n\r\n---\r\n\r\n### é«˜çº§ç”¨æ³•\r\n\r\nMarkdown è¿˜æœ‰ä¸€ä¸ªç‰¹åˆ«ç”¨æ³•ï¼Œå°±æ˜¯åœ¨ä½ éœ€è¦çš„æ—¶å€™å¯ä»¥ç›´æŽ¥ä¹¦å†™ HTML ä»£ç ã€‚\r\n\r\n<input type=\"text\" placeholder=\"è¿™æ˜¯ä¸ªè¾“å…¥æ¡†ï¼\" />\r\n\r\nåªè¦æŽŒæ¡äº†ä¸Šé¢çš„è¿™äº›ä»‹ç»ï¼Œä½ å°±å·²ç»å…¥é—¨äº†ï¼ç»§ç»­å†™ä½œå§ï¼', '<p>Yeahï¼Œåšå®¢ä¸Šçº¿äº†ï¼è¿™ç¯‡æ–‡ç« çš„ç›®çš„æ˜¯å‘ä½ ä»‹ç» Ghost ç¼–è¾‘å™¨å¹¶å¸®ä½ å¿«é€Ÿä¸Šæ‰‹ã€‚é€šè¿‡ <code>&lt;your blog URL&gt;/ghost/</code> é“¾æŽ¥å°±å¯ä»¥ç™»å½•ç³»ç»ŸåŽå°ç®¡ç†ä½ çš„åšå®¢å†…å®¹äº†ã€‚å½“ä½ è¿›å…¥åŽå°ï¼Œä½ å°±èƒ½çœ‹åˆ°å·¦ä¾§æ–‡ç« åˆ—è¡¨å¤„åˆ—å‡ºçš„è¿™ç¯‡æ–‡ç« ï¼Œå³ä¾§å°±æ˜¯è¿™ç¯‡æ–‡ç« çš„é¢„è§ˆæ•ˆæžœã€‚ç‚¹å‡»é¢„è§ˆæ å³ä¸Šè§’çš„é“…ç¬”å›¾æ ‡å°±èƒ½è¿›å…¥å†…å®¹ç¼–è¾‘é¡µé¢ã€‚ </p>\n\n<h2 id=\"\">å¿«é€Ÿå…¥é—¨</h2>\n\n<p>Ghost ä½¿ç”¨ Markdown è¯­æ³•ä¹¦å†™å†…å®¹ã€‚ç®€å•æ¥è¯´ï¼ŒMarkdown å°±æ˜¯ä¸€ç§ç®€åŒ–çš„ä¹¦å†™æ ¼å¼ï¼</p>\n\n<p>ç”¨ Markdown è¯­æ³•å†™ä½œæ˜¯å¾ˆå®¹æ˜“çš„ã€‚åœ¨ç¼–è¾‘ç•Œé¢çš„å·¦ä¾§å°±æ˜¯ä½ å†™ä½œçš„åœ°æ–¹ã€‚åœ¨ä½ è®¤ä¸ºéœ€è¦çš„æ—¶å€™ï¼Œå¯ä»¥ä½¿ç”¨ä»¥ä¸‹è¿™äº›è¯­æ³•æ¥æ ¼å¼åŒ–ä½ çš„å†…å®¹ã€‚ä¾‹å¦‚ä¸‹é¢è¿™ä¸ªæ— åºåˆ—è¡¨ï¼š</p>\n\n<ul>\n<li>Item number one</li>\n<li>Item number two\n<ul><li>A nested item</li></ul></li>\n<li>A final item</li>\n</ul>\n\n<p>è¿˜å¯ä»¥æ˜¯æœ‰åºåˆ—è¡¨ï¼š</p>\n\n<ol>\n<li>Remember to buy some milk  </li>\n<li>Drink the milk  </li>\n<li>Tweet that I remembered to buy the milk, and drank it</li>\n</ol>\n\n<h3 id=\"\">é“¾æŽ¥</h3>\n\n<p>å¦‚æžœè¦é“¾æŽ¥å…¶å®ƒé¡µé¢ï¼Œå¯ä»¥ç›´æŽ¥æŠŠé¡µé¢çš„ URL ç²˜è´´è¿‡æ¥ï¼Œä¾‹å¦‚ <a href=\"http://www.ghostchina.com\">http://www.ghostchina.com</a> - ä¼šè¢«è‡ªåŠ¨è¯†åˆ«ä¸ºé“¾æŽ¥ã€‚ä½†æ˜¯ï¼Œå¦‚æžœä½ æƒ³è‡ªå®šä¹‰é“¾æŽ¥æ–‡æœ¬ï¼Œå¯ä»¥åƒè¿™æ ·ï¼š <a href=\"http://www.ghostchina.com\">Ghost ä¸­æ–‡ç½‘</a>ã€‚å¾ˆç®€å•å§ï¼</p>\n\n<h3 id=\"\">å›¾ç‰‡</h3>\n\n<p>æ’å…¥å›¾ç‰‡ä¹Ÿæ²¡é—®é¢˜ï¼å‰ææ˜¯ä½ äº‹å…ˆçŸ¥é“å›¾ç‰‡çš„ URLï¼Œç„¶åŽåƒä¸‹é¢è¿™æ ·ï¼š</p>\n\n<p><img src=\"http://static.ghostchina.com/image/3/fe/34a9831916be9db1381ecb320491e.png\" alt=\"The Ghost Logo\" /></p>\n\n<p>å¦‚æžœå›¾ç‰‡åœ¨æœ¬åœ°çš„ç¡¬ç›˜é‡Œæ€Žä¹ˆåŠžï¼Ÿä¹Ÿå¾ˆç®€å•ï¼åƒä¸‹é¢è¿™æ ·ä¹¦å†™å°±èƒ½ä¸ºå›¾ç‰‡é¢„ç•™ä¸€ä¸ªä½ç½®ï¼Œç„¶åŽä½ å¯ä»¥ç»§ç»­å†™ä½œï¼Œå›žå¤´å†é€šè¿‡æ‹–æ‹½çš„æ–¹å¼æŠŠå›¾ç‰‡ä¸Šä¼ åˆ°æœåŠ¡å™¨ä¸Šã€‚</p>\n\n<h3 id=\"\">å¼•ç”¨</h3>\n\n<p>æœ‰äº›æ—¶å€™æˆ‘ä»¬éœ€è¦å¼•ç”¨åˆ«äººè¯´çš„è¯ï¼Œå¯ä»¥è¿™æ ·ï¼š</p>\n\n<blockquote>\n  <p>Wisdomous - it\'s definitely a word.</p>\n</blockquote>\n\n<h3 id=\"\">ä»£ç </h3>\n\n<p>æˆ–è®¸ä½ æ˜¯ä¸ªç å†œï¼Œéœ€è¦è´´ä¸€äº›ä»£ç åˆ°æ–‡ç« é‡Œï¼Œå¯ä»¥é€šè¿‡ä¸¤ä¸ªå¼•å·ï¼ˆTab é”®ä¸Šé¢çš„é‚£ä¸ªé”®ï¼‰åŠ å…¥è¡Œå†…ä»£ç  <code>&lt;code&gt;</code>ã€‚å¦‚æžœéœ€è¦åŠ å…¥å¤§æ®µçš„ä»£ç ï¼Œå¯ä»¥åœ¨ä»£ç å‰åŠ  4 ä¸ªç©ºæ ¼ç¼©è¿›ï¼Œè¿™å°±æ˜¯ Markdown çš„è¯­æ³•ã€‚</p>\n\n<pre><code>.awesome-thing {\n    display: block;\n    width: 100%;\n}\n</code></pre>\n\n<h3 id=\"\">åˆ†å‰²çº¿</h3>\n\n<p>åœ¨ä»»ä¸€æ–°è¡Œè¾“å…¥ 3 ä¸ªæˆ–æ›´å¤šçš„çŸ­æ¨ªçº¿ï¼ˆå‡å·ï¼‰å°±æ˜¯ä¸€æ¡åˆ†éš”çº¿äº†ã€‚</p>\n\n<hr />\n\n<h3 id=\"\">é«˜çº§ç”¨æ³•</h3>\n\n<p>Markdown è¿˜æœ‰ä¸€ä¸ªç‰¹åˆ«ç”¨æ³•ï¼Œå°±æ˜¯åœ¨ä½ éœ€è¦çš„æ—¶å€™å¯ä»¥ç›´æŽ¥ä¹¦å†™ HTML ä»£ç ã€‚</p>\n\n<p><input type=\"text\" placeholder=\"è¿™æ˜¯ä¸ªè¾“å…¥æ¡†ï¼\" /></p>\n\n<p>åªè¦æŽŒæ¡äº†ä¸Šé¢çš„è¿™äº›ä»‹ç»ï¼Œä½ å°±å·²ç»å…¥é—¨äº†ï¼ç»§ç»­å†™ä½œå§ï¼</p>', null, '0', '0', 'published', 'zh_CN', null, null, '1', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('2', '6089e208-4597-4d52-8b28-37b39840f13f', 'title', 'title', 'title', '<p>title</p>', null, '0', '0', 'published', 'zh_CN', null, null, '1', '2017-03-20 13:30:53', '1', '2017-03-20 13:35:56', '1', '2017-03-20 13:31:41', '1');
COMMIT;

-- ----------------------------
--  Table structure for `posts_tags`
-- ----------------------------
DROP TABLE IF EXISTS `posts_tags`;
CREATE TABLE `posts_tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `posts_tags_post_id_foreign` (`post_id`),
  KEY `posts_tags_tag_id_foreign` (`tag_id`),
  CONSTRAINT `posts_tags_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`),
  CONSTRAINT `posts_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `posts_tags`
-- ----------------------------
BEGIN;
INSERT INTO `posts_tags` VALUES ('1', '1', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `refreshtokens`
-- ----------------------------
DROP TABLE IF EXISTS `refreshtokens`;
CREATE TABLE `refreshtokens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `expires` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `refreshtokens_token_unique` (`token`),
  KEY `refreshtokens_user_id_foreign` (`user_id`),
  KEY `refreshtokens_client_id_foreign` (`client_id`),
  CONSTRAINT `refreshtokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `refreshtokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `refreshtokens`
-- ----------------------------
BEGIN;
INSERT INTO `refreshtokens` VALUES ('4', 'ySlvxprYEXv9FT51zFf44wUkvRrJsfSz8vCIY3CIfDARTwgbimYZ3CQwkBCyrHyMUuuVUWJP9cOIEwpCr2Nq9ad7HrlitphFEpRWDWlqQqjAseUnvy7BezzFvverfHjrjPcBnUXjm8wLDGooT2Yvruwi7YCnnTAwQNkmdL3CucF5xLMJOIKsy8XfxQ3CtFSDyl0OOWI9Tq51oku6v9J4RycC5BgL2BDfZFuDVglzyGukyuIf8j3jRsGUxULwy4q', '1', '1', '1492570462668');
COMMIT;

-- ----------------------------
--  Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `roles`
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES ('1', '6a9d72ca-c19b-406e-b5ca-b2be59662fbe', 'Administrator', 'ç®¡ç†å‘˜', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('2', 'fe7cfa4d-ea5d-4116-bc6b-df3bd60ad78e', 'Editor', 'ç¼–è¾‘', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('3', '680e28d1-c56e-4b7f-ad46-6c55b1a59b75', 'Author', 'ä½œè€…', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1'), ('4', '9bad8ca4-0ac2-464d-8898-f705bd484bd9', 'Owner', 'åšå®¢æ‰€æœ‰è€…', '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1');
COMMIT;

-- ----------------------------
--  Table structure for `roles_users`
-- ----------------------------
DROP TABLE IF EXISTS `roles_users`;
CREATE TABLE `roles_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `roles_users`
-- ----------------------------
BEGIN;
INSERT INTO `roles_users` VALUES ('1', '4', '1');
COMMIT;

-- ----------------------------
--  Table structure for `settings`
-- ----------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `key` varchar(150) NOT NULL,
  `value` text,
  `type` varchar(150) NOT NULL DEFAULT 'core',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `settings`
-- ----------------------------
BEGIN;
INSERT INTO `settings` VALUES ('1', '2ddf3319-6b0d-4edf-882e-f4099ab7d2af', 'databaseVersion', '004', 'core', '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1'), ('2', '8d0858df-6739-4d39-9280-83c5c3c7a13b', 'dbHash', '0ac29e64-213b-46f2-be3d-b33e896e69aa', 'core', '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1'), ('3', '39e71376-1057-4312-bf37-dfc7b498be99', 'nextUpdateCheck', '1492048450', 'core', '2017-01-25 14:40:26', '1', '2017-04-12 09:54:11', '1'), ('4', '6a01b82a-9e8a-4662-9abb-bf005be0dc5c', 'displayUpdateNotification', '0.7.0', 'core', '2017-01-25 14:40:26', '1', '2017-04-12 09:54:11', '1'), ('5', '269f9133-2525-45da-b465-150c0826f9a3', 'title', 'wxing', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('6', 'cb52b733-b73a-4f87-8333-1a641a0c8249', 'description', 'Thoughts, stories and ideas.', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('7', 'ddb32b04-781c-4a95-ae92-b3c86d1996da', 'logo', '', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('8', '7310cba4-837d-4dfa-8234-af869fbb41d7', 'cover', '', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('9', '8d812ebc-abdc-424b-b7fb-aa68097673e3', 'defaultLang', 'zh_CN', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('10', '6707c130-d53b-4c3f-8a5e-a4f55a88dba0', 'postsPerPage', '5', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('11', '3ec278f4-58d8-4116-aaa9-db2fc4b034e5', 'forceI18n', 'true', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('12', '19200b52-f89d-4363-935c-13e6a71bd28d', 'permalinks', '/:slug/', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1'), ('13', 'dc7bb83a-d59c-436f-bb69-c2cdabb187e3', 'ghost_head', '', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('14', '7f4a85e0-5062-4534-967c-4f563bcbaaab', 'ghost_foot', '', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('15', '9ed17a49-724c-47dd-81f1-333b8894f8d0', 'labs', '{}', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('16', 'bbf37906-7c7b-4d3d-99ef-cb342981f55e', 'navigation', '[{\"label\":\"é¦–é¡µ\",\"url\":\"/\"},{\"label\":\"å…¶ä»–\",\"url\":\"/title\"}]', 'blog', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('17', '49ddc94c-1637-4112-9a74-0a077dace175', 'activeApps', '[]', 'app', '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1'), ('18', '2f513713-941d-45a9-808f-f0852fec417f', 'installedApps', '[]', 'app', '2017-01-25 14:40:26', '1', '2017-04-12 09:53:55', '1'), ('19', '39a0f963-9c4c-4413-9e86-346bc5273b10', 'isPrivate', 'false', 'private', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('20', '996b3fa1-3048-4596-a2d8-3a2cea08e901', 'password', '', 'private', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:03', '1'), ('21', 'd5908dfc-3980-46e6-94f9-908d88b1f1d3', 'activeTheme', 'magnum-master', 'theme', '2017-01-25 14:40:26', '1', '2017-03-20 13:31:02', '1');
COMMIT;

-- ----------------------------
--  Table structure for `tags`
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `image` text,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` int(11) DEFAULT NULL,
  `meta_title` varchar(150) DEFAULT NULL,
  `meta_description` varchar(200) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tags_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tags`
-- ----------------------------
BEGIN;
INSERT INTO `tags` VALUES ('1', 'd2b5229c-55d7-46dc-ad88-4ee42dbe0a61', 'ç³»ç»Ÿç®€ä»‹', 'getting-started', null, null, '0', null, null, null, '2017-01-25 14:40:24', '1', '2017-01-25 14:40:24', '1');
COMMIT;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `password` varchar(60) NOT NULL,
  `email` varchar(254) NOT NULL,
  `image` text,
  `cover` text,
  `bio` varchar(200) DEFAULT NULL,
  `website` text,
  `location` text,
  `accessibility` text,
  `status` varchar(150) NOT NULL DEFAULT 'active',
  `language` varchar(6) NOT NULL DEFAULT 'zh_CN',
  `meta_title` varchar(150) DEFAULT NULL,
  `meta_description` varchar(200) DEFAULT NULL,
  `tour` text,
  `last_login` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_slug_unique` (`slug`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('1', '560b5202-b927-4da9-8661-32461e5c41a6', '452110895@qq.com', '452110895', '$2a$10$KLJY/pN017ie/todF0W6wuNLj9Y/pSsjcQdKTLCMqLuk1AHTDZHSW', '452110895@qq.com', null, null, null, null, null, null, 'active', 'zh_CN', null, null, null, '2017-04-12 09:54:29', '2017-01-25 14:40:26', '1', '2017-04-12 09:54:29', '1'), ('5', '560b5202-b927-4da9-8661-32461e5c41a7', '452110896@qq.com', '452110896', '$2a$10$KLJY/pN017ie/todF0W6wuNLj9Y/pSsjcQdKTLCMqLuk1AHTDZHSW', '452110896@qq.com', null, null, null, null, null, null, 'active', 'zh_CN', null, null, null, null, '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1'), ('6', '560b5202-b927-4da9-8661-32461e5c2174', '452116232@qq.com', '452117590', '$2a$10$KLJY/pN017ie/todF0W6wuNLj9Y/pSsjcQdKTLCMqLuk1AHTDZHSW', '452114053@qq.com', null, null, null, null, null, null, 'active', 'zh_CN', null, null, null, null, '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1'), ('7', '560b5202-b927-4da9-8661-32461e5c5272', '452118721@qq.com', '452114246', '$2a$10$KLJY/pN017ie/todF0W6wuNLj9Y/pSsjcQdKTLCMqLuk1AHTDZHSW', '452111818@qq.com', null, null, null, null, null, null, 'active', 'zh_CN', null, null, null, null, '2017-01-25 14:40:26', '1', '2017-01-25 14:40:26', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
